Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ConvertsFrom (FK)(PK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_CVN_UOM_FM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
ConvertsTo (FK)(PK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_CVN_UOM_TO | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
Amount | The multiplier that converts the FromUOM to the ToUOM. It is intended to represent a ratio. It applies to simple conversions. A separate attribute is used to define a conversion formula for more complex conversions (e.g. between degrees Faharenheit and degress Celcius) | MO_UOM_CVN | Quantity | DECIMAL(9,3) | |
ConversionRuleDescription | A short text representation of the formula used to convert between two distinct units of measure. For example to convert degrees celcius to degrees Fahrenheit use F=(C * 9/5)+32. It requires a little more information that a simple ratio. | DE_CVN_RUL | DescriptionShort | varchar(255) | |